[dbo].[asi_GroupCopySimpleMembership]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GroupCopySimpleMembership

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@srcGroupKey	uniqueidentifier	16
@destGroupKey	uniqueidentifier	16
@userKey	uniqueidentifier	16
@now	datetime	8

CREATE PROCEDURE [dbo].[asi_GroupCopySimpleMembership] (@srcGroupKey uniqueidentifier, @destGroupKey uniqueidentifier, @userKey uniqueidentifier, @now datetime)
AS
BEGIN

INSERT INTO GroupMember (GroupMemberKey, GroupKey, MemberContactKey, IsActive, CreatedByUserKey, CreatedOn, UpdatedByUserKey, UpdatedOn, DropDate, JoinDate)
    SELECT newid(), @destGroupKey, MemberContactKey, IsActive, @userKey, @now, @userKey, @now, DropDate, JoinDate
        FROM GroupMember
        WHERE GroupMember.GroupKey=@srcGroupKey
END

GO